Manage The Relationship Between Tables 9
1) Manage the relationship between Dim_JRP_Jobs and Fact_Submission_Interview_Offer table
Create the relationship between Dim_JRP_Jobs and Fact_Submissions_Interview_Offer table
- (1) Right Click to the Relationship --->Choose Properties
- (2) Change Cross Filter Direction to Both
- (3) Click OK
2) Manage Relationship between Dim_JRP_Tags and Fact_JobReferral, Dim_JRP_Clients and Fact_JobReferral table
Repeat step (1), (2), and (3) above to change the Cross Filter Direction between Dim_JRP_Tags and Fact_JobRefrral, Dim_JRP_Clients and Fact_JobReferral tables to Both
THE RELATIONSHIPS WILL LOOK LIKE THIS
If you went to know more about managing the relashinshp
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand